Cannot center entry across multiple cells due to space in one of the cells.
Cause:
This problem occurs because there is a space character typed in one of the cells (other than the entry).
Solution:
Select and clear the contents of all the cells except the one that contains the entry.
1) Select all the cells except the one that contains the entry.
2) Select the 'Edit' menu and select 'Clear'. (A submenu appears.)
3) Select 'Contents' from the submenu.